﻿<%@ Page Language="C#" MasterPageFile="~/Master/Site.Master" AutoEventWireup="true"
    CodeBehind="DataExpire.aspx.cs" Inherits="聚欣订单分析.DataExpire" Title="无标题页" %>

<%@ Register Assembly="DevExpress.Web.v18.1, Version=18.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web" TagPrefix="dx" %>


<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="CPH_NAV" runat="server">
    <h2>维保到期</h2>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="CPH_Contents" runat="server">
    <div class="content-page">
        <div class="content">
            <div class="am-g">
                <!-- Row start -->
                <div class="card-box">
                    <dx:ASPxGridView ID="ASPxGridView1" runat="server" Width="100%" AutoGenerateColumns="False"
                        DataSourceID="SqlDataSource1">
                        <Columns>
                            <dx:GridViewCommandColumn VisibleIndex="0" Width="40px" ShowClearFilterButton="true">
                            </dx:GridViewCommandColumn>
                            <dx:GridViewDataTextColumn FieldName="年份" VisibleIndex="0">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="订单号" VisibleIndex="1">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="省" VisibleIndex="2">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="地市" VisibleIndex="3">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="运营商" VisibleIndex="4" Width="250px">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn Caption="项目名称" FieldName="项目" VisibleIndex="5" Width="250px">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="类型" VisibleIndex="6">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="有无订单合同" VisibleIndex="6">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataDateColumn FieldName="订单日期" VisibleIndex="7">
                            </dx:GridViewDataDateColumn>
                            <dx:GridViewDataTextColumn FieldName="订单金额" VisibleIndex="8">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="责任人" VisibleIndex="9">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataDateColumn FieldName="合同签订时间" VisibleIndex="10">
                            </dx:GridViewDataDateColumn>
                            <dx:GridViewDataDateColumn FieldName="维保时间" VisibleIndex="11">
                            </dx:GridViewDataDateColumn>
                            <dx:GridViewDataTextColumn FieldName="备注" VisibleIndex="12">
                            </dx:GridViewDataTextColumn>
                        </Columns>
                        <Settings ShowGroupPanel="true" ShowHorizontalScrollBar="true" ShowFilterRow="true"
                            ShowFilterRowMenu="true" ShowFilterBar="Visible" ShowFooter="True" />
                        <SettingsPager PageSize="30">
                        </SettingsPager>
                    </dx:ASPxGridView>
                    <table>
                        <tr>
                            <td>
                                <dx:ASPxButton ID="btnExcel" runat="server" Text="导出Excel" OnClick="btnExcel_Click">
                                    <Image Url="~/images/ICON/Excel.gif">
                                    </Image>
                                </dx:ASPxButton>
                            </td>
                        </tr>
                    </table>
                </div>
            </div>
            <!-- Row end -->
        </div>
    </div>
    <dx:ASPxGridViewExporter ID="ASPxGridViewExporter1" GridViewID="ASPxGridView1" runat="server">
    </dx:ASPxGridViewExporter>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:JXDDConnectionString %>"
        SelectCommand="SELECT * FROM [tbl_DDB] where 维保时间<GETDATE() and 订单取消='否'"></asp:SqlDataSource>
</asp:Content>
